package com.isoft.filelistener.dao;

import com.isoft.filelistener.entity.*;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@Mapper
public interface DfoeDfieDao {
    @Insert("insert into TEAM_03.META(SENDER,RECEIVER,SEQUENCE,SENDTIME,TYPE,STYP,META_ID) " +
            "values(#{metaData.sender},#{metaData.receiver},#{metaData.sequence},#{metaData.sendTime},#{metaData.type},#{metaData.styp},#{id})")
    int InsertDfoeMeta(@Param("metaData") MetaData metaData,@Param("id") String id);

    @Insert("insert into TEAM_03.DFOE_DFIE_ARPT(APNO,APCD,FPTT,FETT,FRTT,FPLT,FELT,FRLT,APAT,META_ID) " +
            "values(#{arpt.apno},#{arpt.apcd},#{arpt.fptt},#{arpt.fett},#{arpt.frtt},#{arpt.fplt},#{arpt.felt},#{arpt.frlt},#{arpt.apat},#{id})")
    int InsertDfoeArpt(@Param("arpt") DfoeDfieDfltArpt arpt,@Param("id") String id);

    @Insert("insert into TEAM_03.DFOE_DFIE(META_ID,FLID,AFID,FFID,FIDE,TEST,AWCD,FLNO,FF    XD,FIMD,FLIO,FLTK,FATT,PATT,MFID,MFFI,CFTP,CFNO,STAT,ABST,ABRS,ISTA,IAST,IARS,MSTA,MABS,MABR,MIST,MIAS" +
            ",MIAR,BORT,MBOR,TBRT,MTBR,LBDT,MLBD,POKT,MPOK,APOT,DETT,DRTT,DELT,DRLT,VIP,SPLG,PAST,GTLS,BLLS,FCES,FCEE,FCRS,FCRE,MCES,MCEE,MCRS,MCRE,FCDP,MCDP,CHLS,STLS,NMCD,JMCD,FLDT,LLDT,CONT,PROX) " +
            "values(#{id},#{dfie.flid},#{dfie.afid},#{dfie.ffid},#{dfie.fide},#{dfie.test},#{dfie.awcd},#{dfie.flno},#{dfie.ffxd},#{dfie.fimd},#{dfie.flio},#{dfie.fltk},#{dfie.fatt}" +
            ",#{dfie.patt},#{dfie.mfid},#{dfie.mffi},#{dfie.cftp},#{dfie.cfno},#{dfie.stat},#{dfie.abst},#{dfie.abrs},#{dfie.ista},#{dfie.iast},#{dfie.iars},#{dfie.msta},#{dfie.mabs},#{dfie.mabr},#{dfie.mist},#{dfie.mias}" +
            ",#{dfie.miar},#{dfie.bort},#{dfie.mbor},#{dfie.tbrt},#{dfie.mtbr},#{dfie.lbdt},#{dfie.mlbd},#{dfie.pokt},#{dfie.mpok},#{dfie.apot},#{dfie.dett},#{dfie.drtt},#{dfie.delt},#{dfie.drlt},#{dfie.vip},#{dfie.sflg},#{dfie.past}" +
            ",#{dfie.gtls},#{dfie.blls},#{ckls.fces},#{ckls.fcee},#{ckls.fcrs},#{ckls.fcre},#{ckls.mces},#{ckls.mcee},#{ckls.mcrs},#{ckls.mcre},#{ckls.fcdp},#{ckls.mcdp},#{dfie.chls},#{dfie.stls},#{tmcd.nmcd},#{tmcd.jmcd},#{dfie.fldt},#{dfie.lldt},#{dfie.cont},#{dfie.prox})")
    int InsertDfoeDfie(@Param("dfie")DfoeDfieDflt dfie, @Param("ckls")DfoeDfieDfltCkls ckls, @Param("tmcd")DfoeDfieDfltTmcd tmcd,@Param("id") String id);
}
